// 结账了的利润表
const {DataTypes, db } = require("../db");
db.define('profitHist', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,comment:'租户ID'}, 
code:{type: DataTypes.STRING(50),comment:'编码'}, 
op:{type: DataTypes.STRING(10),comment:'运算动作 加/减'}, 
name:{type: DataTypes.STRING(100),comment:'项目'}, 
amountY:{type: DataTypes.DECIMAL(18, 2),comment:'本年累计'}, 
amountM:{type: DataTypes.DECIMAL(18, 2),comment:'本月累计'}, 
amountM3:{type: DataTypes.DECIMAL(18, 2),comment:'季度累计'}, 
space:{type: DataTypes.INTEGER,comment:'间距'}, 
isSubject:{type: DataTypes.INTEGER,comment:'1是科目名称'}, 
subjectName:{type: DataTypes.STRING(100),comment:'显示 名称'}, 
subjectCode:{type: DataTypes.STRING(50),comment:'科目编码'}, 
direct:{type: DataTypes.STRING(10),comment:'方向'}, 
hasChild:{type: DataTypes.INTEGER,comment:''}, 
ym:{type: DataTypes.STRING(10),comment:''}, 
zqId:{type: DataTypes.INTEGER,comment:''}, 

}, {
    tableName: 'profit_hist',
    timestamps: false,
    comment: '结账了的利润表'
});